package com.egao.common.module.student.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.egao.common.module.student.entity.StudentInten;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * @author lym
 * @date 2022/5/16 16:49
 */
public interface StudentIntenMapper extends BaseMapper<StudentInten> {

    /**
     * 考公统计
     *
     * @param yearId       毕业年份
     * @param collegeCodes 学院代码集合
     * @return List<Map < String, Integer>>
     */
    List<Map<String, Object>> kgStatistics(@Param("yearId") Integer yearId, @Param("collegeCodes") List<String> collegeCodes, @Param("bjhms") List<String> bjhms);

    List<Map<String, Object>> kgTypeStatistics(@Param("yearId") Integer yearId, @Param("collegeCodes") List<String> collegeCodes, @Param("bjhms") List<String> bjhms);

    List<Map<String, Object>> sxStatistics(@Param("yearId") Integer yearId, @Param("collegeCodes") List<String> collegeCodes, @Param("bjhms") List<String> bjhms);

    List<Map<String, Object>> sxMajorStatistics(@Param("yearId") Integer yearId, @Param("collegeCodes") List<String> collegeCodes, @Param("bjhms") List<String> bjhms);

    List<Map<String, Object>> kyStatistics(@Param("yearId") Integer yearId,
                                            @Param("collegeCodes") List<String> collegeCodes,
                                            @Param("bjhms") List<String> bjhms);

    List<Map<String, Object>> kyMajorStatistics(@Param("yearId") Integer yearId,
                                            @Param("collegeCodes") List<String> collegeCodes,
                                            @Param("bjhms") List<String> bjhms);

    List<StudentInten> listAll(@Param("yearId") Integer yearId);
}
